/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package neobux;

import com.sun.rave.web.ui.appbase.AbstractPageBean;
import com.sun.webui.jsf.component.DropDown;
import com.sun.webui.jsf.component.StaticText;
import com.sun.webui.jsf.model.SingleSelectOptionsList;
import javax.faces.FacesException;
import java.sql.*;

/**
 * <p>Page bean that corresponds to a similarly named JSP page.  This
 * class contains component definitions (and initialization code) for
 * all components that you have defined on this page, as well as
 * lifecycle methods and event handlers where you may add behavior
 * to respond to incoming events.</p>
 *
 * @version BuyAds.java
 * @version Created on Dec 18, 2008, 7:46:40 PM
 * @author Administrator
 */

public class BuyAds extends AbstractPageBean {
    // <editor-fold defaultstate="collapsed" desc="Managed Component Definition">
    private int id;
    private String username;
    private String adName;
    private String url;
    private String description;
    private int category;
    private double adPackage;
    private double money;
    private int clicksLeft;
    /**
     * <p>Automatically managed component initialization.  <strong>WARNING:</strong>
     * This method is automatically generated, so any user-specified code inserted
     * here is subject to being replaced.</p>
     */
    private void _init() throws Exception {
        catDropDefaultOptions.setOptions(new com.sun.webui.jsf.model.Option[]{new com.sun.webui.jsf.model.Option("", "Select Category"), new com.sun.webui.jsf.model.Option("1", "1- Arts & Entertainment"), new com.sun.webui.jsf.model.Option("2", "2- Business & Money"), new com.sun.webui.jsf.model.Option("3", "3- Computers & Internet"), new com.sun.webui.jsf.model.Option("4", "4- Health & Education"), new com.sun.webui.jsf.model.Option("5", "5- Travel & Shopping")});
        packDropDefaultOptions.setOptions(new com.sun.webui.jsf.model.Option[]{new com.sun.webui.jsf.model.Option("", "Select Ad Package"), new com.sun.webui.jsf.model.Option("10", "1000 clicks / 10 $"), new com.sun.webui.jsf.model.Option("20", "2000 clicks / 20 $"), new com.sun.webui.jsf.model.Option("50", "5000 clicks / 50 $"), new com.sun.webui.jsf.model.Option("100", "10000 clicks / 100 $")});
    }
    private SingleSelectOptionsList catDropDefaultOptions = new SingleSelectOptionsList();

    public SingleSelectOptionsList getCatDropDefaultOptions() {
        return catDropDefaultOptions;
    }

    public void setCatDropDefaultOptions(SingleSelectOptionsList ssol) {
        this.catDropDefaultOptions = ssol;
    }
    private SingleSelectOptionsList packDropDefaultOptions = new SingleSelectOptionsList();

    public SingleSelectOptionsList getPackDropDefaultOptions() {
        return packDropDefaultOptions;
    }

    public void setPackDropDefaultOptions(SingleSelectOptionsList ssol) {
        this.packDropDefaultOptions = ssol;
    }
    private DropDown catDrop = new DropDown();

    public DropDown getCatDrop() {
        return catDrop;
    }

    public void setCatDrop(DropDown dd) {
        this.catDrop = dd;
    }
    private DropDown packDrop = new DropDown();

    public DropDown getPackDrop() {
        return packDrop;
    }

    public void setPackDrop(DropDown dd) {
        this.packDrop = dd;
    }
    private StaticText staticText2 = new StaticText();

    public StaticText getStaticText2() {
        return staticText2;
    }

    public void setStaticText2(StaticText st) {
        this.staticText2 = st;
    }
    private StaticText staticText3 = new StaticText();

    public StaticText getStaticText3() {
        return staticText3;
    }

    public void setStaticText3(StaticText st) {
        this.staticText3 = st;
    }
    private StaticText staticText4 = new StaticText();

    public StaticText getStaticText4() {
        return staticText4;
    }

    public void setStaticText4(StaticText st) {
        this.staticText4 = st;
    }
    private StaticText staticText5 = new StaticText();

    public StaticText getStaticText5() {
        return staticText5;
    }

    public void setStaticText5(StaticText st) {
        this.staticText5 = st;
    }
    private StaticText staticText1 = new StaticText();

    public StaticText getStaticText1() {
        return staticText1;
    }

    public void setStaticText1(StaticText st) {
        this.staticText1 = st;
    }

    // </editor-fold>

    /**
     * <p>Construct a new Page bean instance.</p>
     */
    public BuyAds() {
    }

    /**
     * <p>Callback method that is called whenever a page is navigated to,
     * either directly via a URL, or indirectly via page navigation.
     * Customize this method to acquire resources that will be needed
     * for event handlers and lifecycle methods, whether or not this
     * page is performing post back processing.</p>
     *
     * <p>Note that, if the current request is a postback, the property
     * values of the components do <strong>not</strong> represent any
     * values submitted with this request.  Instead, they represent the
     * property values that were saved for this view when it was rendered.</p>
     */
    @Override
    public void init() {
        // Perform initializations inherited from our superclass
        super.init();
        // Perform application initialization that must complete
        // *before* managed components are initialized
        // TODO - add your own initialiation code here
        id = getSessionBean1().getId();
        username = getSessionBean1().getUsername();
        staticText1.setText("Logged in as "+username);
        staticText2.setText("");
        try{
            Class.forName("org.apache.derby.jdbc.ClientDriver");
            Connection conn = DriverManager.getConnection("jdbc:derby://localhost:1527/itubux","itubux","itubux");

            String user = "SELECT PARA FROM KULLANICI WHERE ID = " +id;

            Statement smt = conn.createStatement();
            ResultSet result1 = smt.executeQuery(user);

            if(result1.next()){
                money = result1.getDouble("PARA");
                staticText3.setText("You have "+money+" $");
            }
        }
        catch(ClassNotFoundException e){

               e.printStackTrace();

        }
        catch(SQLException e){

               e.printStackTrace();

        }


        // <editor-fold defaultstate="collapsed" desc="Managed Component Initialization">
        // Initialize automatically managed components
        // *Note* - this logic should NOT be modified
        try {
            _init();
        } catch (Exception e) {
            log("BuyAds Initialization Failure", e);
            throw e instanceof FacesException ? (FacesException) e: new FacesException(e);
        }

        // </editor-fold>
        // Perform application initialization that must complete
        // *after* managed components are initialized
        // TODO - add your own initialization code here
    }

    /**
     * <p>Callback method that is called after the component tree has been
     * restored, but before any event processing takes place.  This method
     * will <strong>only</strong> be called on a postback request that
     * is processing a form submit.  Customize this method to allocate
     * resources that will be required in your event handlers.</p>
     */
    @Override
    public void preprocess() {
    }

    /**
     * <p>Callback method that is called just before rendering takes place.
     * This method will <strong>only</strong> be called for the page that
     * will actually be rendered (and not, for example, on a page that
     * handled a postback and then navigated to a different page).  Customize
     * this method to allocate resources that will be required for rendering
     * this page.</p>
     */
    @Override
    public void prerender() {
    }

    /**
     * <p>Callback method that is called after rendering is completed for
     * this request, if <code>init()</code> was called (regardless of whether
     * or not this was the page that was actually rendered).  Customize this
     * method to release resources acquired in the <code>init()</code>,
     * <code>preprocess()</code>, or <code>prerender()</code> methods (or
     * acquired during execution of an event handler).</p>
     */
    @Override
    public void destroy() {
    }

    /**
     * <p>Return a reference to the scoped data bean.</p>
     *
     * @return reference to the scoped data bean
     */
    protected SessionBean1 getSessionBean1() {
        return (SessionBean1) getBean("SessionBean1");
    }

    /**
     * <p>Return a reference to the scoped data bean.</p>
     *
     * @return reference to the scoped data bean
     */
    protected RequestBean1 getRequestBean1() {
        return (RequestBean1) getBean("RequestBean1");
    }

    /**
     * <p>Return a reference to the scoped data bean.</p>
     *
     * @return reference to the scoped data bean
     */
    protected ApplicationBean1 getApplicationBean1() {
        return (ApplicationBean1) getBean("ApplicationBean1");
    }

    public String hyperlink1_action() {
        // TODO: Replace with your code
        return "View";
    }

    public String hyperlink2_action() {
        // TODO: Replace with your code
        return "SurfAds";
    }

    public String hyperlink3_action() {
        // TODO: Replace with your code
        return "BuyAds";
    }

    public String hyperlink4_action() {
        // TODO: Replace with your code
        return "RentRef";
    }

    public String hyperlink5_action() {
        // TODO: Replace with your code
        return "Settings";
    }

    public String hyperlink6_action() {
        // TODO: Replace with your code
        return "AdSettings";
    }

    public String hyperlink7_action() {
        // TODO: Replace with your code
        return "DirectRef";
    }

    public String hyperlink8_action() {
        // TODO: Replace with your code
        return "RentedRef";
    }

    public String hyperlink9_action() {
        // TODO: Replace with your code
        return "CashOut";
    }

    public String hyperlink10_action() {
        // TODO: Replace with your code
        return "History";
    }

    public String buttonLogout_action() {
        // TODO: Process the action. Return value is a navigation
        // case name where null will return to the same page.
        getSessionBean1().destroy();
        return "login";
    }

    public String button2_action() {
        // TODO: Process the action. Return value is a navigation
        // case name where null will return to the same page.
        adPackage = Double.parseDouble(packDrop.getSelected().toString());
        category = Integer.parseInt(catDrop.getSelected().toString());
        clicksLeft = (int)(100*adPackage);

        try{
           Class.forName("org.apache.derby.jdbc.ClientDriver");
           Connection conn = DriverManager.getConnection("jdbc:derby://localhost:1527/itubux","itubux","itubux");

           String usermoney = "SELECT PARA FROM KULLANICI WHERE ID="+id;
           String query = "INSERT INTO REKLAM (KUL_ID, ISIM, URL, ACIKLAMA, TIKSAYISI, KALANTIK, DURUM, KATEGORI) " +
                          "VALUES ("+id+",'"+adName+"','"+url+"','"+description+"',"+0+","+clicksLeft+","+0+","+category+")";
           String purchase = "UPDATE KULLANICI SET PARA="+(money-adPackage)+" WHERE ID="+id;

           Statement smt = conn.createStatement();

           if(money < adPackage){
                  staticText2.setText("You do not have enough money to buy that package.");
                  staticText5.setText("money < adPackage");
           }
           if(money >= adPackage){
                    staticText2.setText("");
                    staticText5.setText("money >= adPackage");
                    //money=money-adPackage;
                    //staticText3.setText("You have "+money+" $");

                    smt = conn.createStatement();
                    /*int result3 =*/ smt.executeUpdate(query);
                    //if(result3 == 1){
                    //staticText2.setText("reklamı insert etti");
                   // }

                    smt = conn.createStatement();
                    int result4 = smt.executeUpdate(purchase);
                    if(result4 == 1){
                        staticText2.setText("You have purchased the advert.");
                    }

           }
       }
       catch(ClassNotFoundException e){

               e.printStackTrace();
               return "failure";
        }
        catch(SQLException e){

               e.printStackTrace();
               return "failure";
        }
        return "BuyAds";
    }

    /**
     * @return the adName
     */
    public String getAdName() {
        return adName;
    }

    /**
     * @param adName the adName to set
     */
    public void setAdName(String adName) {
        this.adName = adName;
    }

    /**
     * @return the url
     */
    public String getUrl() {
        return url;
    }

    /**
     * @param url the url to set
     */
    public void setUrl(String url) {
        this.url = url;
    }

    /**
     * @return the description
     */
    public String getDescription() {
        return description;
    }

    /**
     * @param description the description to set
     */
    public void setDescription(String description) {
        this.description = description;
    }

    /**
     * @return the category
     */
    public int getCategory() {
        return category;
    }

    /**
     * @param category the category to set
     */
    public void setCategory(int category) {
        this.category = category;
    }

    /**
     * @return the adPackage
     */
    public double getAdPackage() {
        return adPackage;
    }

    /**
     * @param adPackage the adPackage to set
     */
    public void setAdPackage(int adPackage) {
        this.adPackage = adPackage;
    }


    /**
     * @return the id
     */
    public int getId() {
        return id;
    }

    /**
     * @param id the id to set
     */
    public void setId(int id) {
        this.id = id;
    }

    public double getMoney() {
        return money;
    }

    public void setMoney(double money) {
        this.money = money;
    }

    /**
     * @return the clicksLeft
     */
    public int getClicksLeft() {
        return clicksLeft;
    }

    /**
     * @param clicksLeft the clicksLeft to set
     */
    public void setClicksLeft(int clicksLeft) {
        this.clicksLeft = clicksLeft;
    }

}

